Dataset statistics
| Number of variables | 16 |
|---|---|
| Number of observations | 150326 |
| Missing cells | 329588 |
| Missing cells (%) | 13.7% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 45.2 MiB |
| Average record size in memory | 315.3 B |
Variable types
| NUM | 11 |
|---|---|
| CAT | 4 |
| DATE | 1 |
Fecha has constant value "150326" | Constant |
Hora has a high cardinality: 59471 distinct values | High cardinality |
ID_Group is highly correlated with ID | High correlation |
ID is highly correlated with ID_Group | High correlation |
Neutral has 27774 (18.5%) missing values | Missing |
Happy has 27774 (18.5%) missing values | Missing |
Sad has 27774 (18.5%) missing values | Missing |
Angry has 27774 (18.5%) missing values | Missing |
Surprised has 27774 (18.5%) missing values | Missing |
Scared has 27774 (18.5%) missing values | Missing |
Disgusted has 27774 (18.5%) missing values | Missing |
Contempt has 27774 (18.5%) missing values | Missing |
Valence has 27774 (18.5%) missing values | Missing |
Arousal has 27774 (18.5%) missing values | Missing |
Heart_Rate has 51848 (34.5%) missing values | Missing |
Hora is uniformly distributed | Uniform |
Happy has 37312 (24.8%) zeros | Zeros |
Sad has 20639 (13.7%) zeros | Zeros |
Angry has 22881 (15.2%) zeros | Zeros |
Surprised has 23112 (15.4%) zeros | Zeros |
Scared has 28871 (19.2%) zeros | Zeros |
Disgusted has 28225 (18.8%) zeros | Zeros |
Contempt has 30555 (20.3%) zeros | Zeros |
Reproduction
| Analysis started | 2020-09-18 16:13:34.435088 |
|---|---|
| Analysis finished | 2020-09-18 16:14:00.332839 |
| Duration | 25.9 seconds |
| Software version | pandas-profiling v2.9.0 |
| Download configuration | config.yaml |
Video_Time
Date
| Distinct | 59471 |
|---|---|
| Distinct (%) | 39.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| Minimum | 2020-09-18 00:00:00 |
|---|---|
| Maximum | 2020-09-18 00:36:23.560000 |
Histogram with fixed size bins (bins=50)
| Distinct | 121312 |
|---|---|
| Distinct (%) | 99.0% |
| Missing | 27774 |
| Missing (%) | 18.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.5216363836 |
|---|---|
| Minimum | 0 |
| Maximum | 0.9761002 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.18173331 |
| Q1 | 0.404725125 |
| median | 0.52866585 |
| Q3 | 0.6444498 |
| 95-th percentile | 0.842287015 |
| Maximum | 0.9761002 |
| Range | 0.9761002 |
| Interquartile range (IQR) | 0.239724675 |
Descriptive statistics
| Standard deviation | 0.1889532438 |
|---|---|
| Coefficient of variation (CV) | 0.3622317188 |
| Kurtosis | -0.09451900079 |
| Mean | 0.5216363836 |
| Median Absolute Deviation (MAD) | 0.11981095 |
| Skewness | -0.1383539582 |
| Sum | 63927.58209 |
| Variance | 0.03570332835 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0.5621756 | 3 | < 0.1% | |
| 0.4755283 | 3 | < 0.1% | |
| 0.4329636 | 3 | < 0.1% | |
| 0.6591297 | 3 | < 0.1% | |
| 0.5168197 | 3 | < 0.1% | |
| 0.3709169 | 3 | < 0.1% | |
| 0.5308301 | 3 | < 0.1% | |
| 0.5852855 | 3 | < 0.1% | |
| 0.5067396 | 2 | < 0.1% | |
| 0.5511025 | 2 | < 0.1% | |
| 0.5599059 | 2 | < 0.1% | |
| 0.8887116 | 2 | < 0.1% | |
| 0.6886443 | 2 | < 0.1% | |
| 0.7424833 | 2 | < 0.1% | |
| 0.5088154 | 2 | < 0.1% | |
| 0.4077134 | 2 | < 0.1% | |
| 0.4237642 | 2 | < 0.1% | |
| 0.4927391 | 2 | < 0.1% | |
| 0.5719758 | 2 | < 0.1% | |
| 0.3328071 | 2 | < 0.1% | |
| 0.4071994 | 2 | < 0.1% | |
| 0.5619428 | 2 | < 0.1% | |
| 0.5197812 | 2 | < 0.1% | |
| 0.522749 | 2 | < 0.1% | |
| 0.5313982 | 2 | < 0.1% | |
| Other values (121287) | 122494 | 81.5% | |
| (Missing) | 27774 | 18.5% |
| Value | Count | Frequency (%) | |
| 0 | 1 | < 0.1% | |
| 7e-09 | 1 | < 0.1% | |
| 9e-09 | 1 | < 0.1% | |
| 1.2e-08 | 1 | < 0.1% | |
| 1.3e-08 | 1 | < 0.1% | |
| 1.7e-08 | 1 | < 0.1% | |
| 2.1e-08 | 1 | < 0.1% | |
| 1.545e-06 | 1 | < 0.1% | |
| 2.904e-06 | 1 | < 0.1% | |
| 3.171e-06 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0.9761002 | 1 | < 0.1% | |
| 0.9760876 | 1 | < 0.1% | |
| 0.9760761 | 1 | < 0.1% | |
| 0.9760695 | 1 | < 0.1% | |
| 0.976042 | 1 | < 0.1% | |
| 0.9760152 | 1 | < 0.1% | |
| 0.9760112 | 1 | < 0.1% | |
| 0.9759278 | 1 | < 0.1% | |
| 0.9758861 | 1 | < 0.1% | |
| 0.9757921 | 1 | < 0.1% |
| Distinct | 72091 |
|---|---|
| Distinct (%) | 58.8% |
| Missing | 27774 |
| Missing (%) | 18.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.07346600264 |
|---|---|
| Minimum | 0 |
| Maximum | 0.9953589 |
| Zeros | 37312 |
| Zeros (%) | 24.8% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.000102532 |
| Q3 | 0.04196257 |
| 95-th percentile | 0.49391828 |
| Maximum | 0.9953589 |
| Range | 0.9953589 |
| Interquartile range (IQR) | 0.04196257 |
Descriptive statistics
| Standard deviation | 0.1681486587 |
|---|---|
| Coefficient of variation (CV) | 2.288795533 |
| Kurtosis | 8.220559269 |
| Mean | 0.07346600264 |
| Median Absolute Deviation (MAD) | 0.000102532 |
| Skewness | 2.897244686 |
| Sum | 9003.405556 |
| Variance | 0.02827397141 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0 | 37312 | 24.8% | |
| 1e-09 | 1411 | 0.9% | |
| 2e-09 | 709 | 0.5% | |
| 3e-09 | 451 | 0.3% | |
| 4e-09 | 353 | 0.2% | |
| 5e-09 | 294 | 0.2% | |
| 6e-09 | 241 | 0.2% | |
| 7e-09 | 215 | 0.1% | |
| 8e-09 | 184 | 0.1% | |
| 9e-09 | 170 | 0.1% | |
| 1e-08 | 155 | 0.1% | |
| 1.1e-08 | 137 | 0.1% | |
| 1.3e-08 | 120 | 0.1% | |
| 1.2e-08 | 118 | 0.1% | |
| 1.4e-08 | 111 | 0.1% | |
| 1.5e-08 | 103 | 0.1% | |
| 1.6e-08 | 99 | 0.1% | |
| 1.8e-08 | 88 | 0.1% | |
| 1.7e-08 | 85 | 0.1% | |
| 1.9e-08 | 79 | 0.1% | |
| 2.1e-08 | 79 | 0.1% | |
| 2.3e-08 | 77 | 0.1% | |
| 2e-08 | 77 | 0.1% | |
| 2.6e-08 | 73 | < 0.1% | |
| 2.2e-08 | 63 | < 0.1% | |
| Other values (72066) | 79748 | 53.1% | |
| (Missing) | 27774 | 18.5% |
| Value | Count | Frequency (%) | |
| 0 | 37312 | 24.8% | |
| 1e-09 | 1411 | 0.9% | |
| 2e-09 | 709 | 0.5% | |
| 3e-09 | 451 | 0.3% | |
| 4e-09 | 353 | 0.2% | |
| 5e-09 | 294 | 0.2% | |
| 6e-09 | 241 | 0.2% | |
| 7e-09 | 215 | 0.1% | |
| 8e-09 | 184 | 0.1% | |
| 9e-09 | 170 | 0.1% |
| Value | Count | Frequency (%) | |
| 0.9953589 | 1 | < 0.1% | |
| 0.985399 | 1 | < 0.1% | |
| 0.9850779 | 1 | < 0.1% | |
| 0.9834555 | 1 | < 0.1% | |
| 0.9825905 | 1 | < 0.1% | |
| 0.9815773 | 1 | < 0.1% | |
| 0.9794983 | 1 | < 0.1% | |
| 0.9771995 | 1 | < 0.1% | |
| 0.9763428 | 1 | < 0.1% | |
| 0.9750316 | 1 | < 0.1% |
| Distinct | 90401 |
|---|---|
| Distinct (%) | 73.8% |
| Missing | 27774 |
| Missing (%) | 18.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.138953194 |
|---|---|
| Minimum | 0 |
| Maximum | 0.9999855 |
| Zeros | 20639 |
| Zeros (%) | 13.7% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 9.16e-07 |
| median | 0.007086779 |
| Q3 | 0.18245805 |
| 95-th percentile | 0.68456401 |
| Maximum | 0.9999855 |
| Range | 0.9999855 |
| Interquartile range (IQR) | 0.182457134 |
Descriptive statistics
| Standard deviation | 0.2363820677 |
|---|---|
| Coefficient of variation (CV) | 1.701163254 |
| Kurtosis | 3.179557031 |
| Mean | 0.138953194 |
| Median Absolute Deviation (MAD) | 0.007086779 |
| Skewness | 1.965602828 |
| Sum | 17028.99183 |
| Variance | 0.05587648191 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0 | 20639 | 13.7% | |
| 1e-09 | 1041 | 0.7% | |
| 2e-09 | 538 | 0.4% | |
| 3e-09 | 377 | 0.3% | |
| 4e-09 | 285 | 0.2% | |
| 5e-09 | 230 | 0.2% | |
| 6e-09 | 192 | 0.1% | |
| 7e-09 | 176 | 0.1% | |
| 8e-09 | 150 | 0.1% | |
| 9e-09 | 135 | 0.1% | |
| 1e-08 | 123 | 0.1% | |
| 1.1e-08 | 113 | 0.1% | |
| 1.2e-08 | 98 | 0.1% | |
| 1.3e-08 | 95 | 0.1% | |
| 1.5e-08 | 88 | 0.1% | |
| 1.4e-08 | 87 | 0.1% | |
| 1.6e-08 | 82 | 0.1% | |
| 1.9e-08 | 69 | < 0.1% | |
| 1.7e-08 | 68 | < 0.1% | |
| 0.9999733 | 68 | < 0.1% | |
| 1.8e-08 | 68 | < 0.1% | |
| 2.2e-08 | 67 | < 0.1% | |
| 0.9999734 | 66 | < 0.1% | |
| 2.1e-08 | 65 | < 0.1% | |
| 2e-08 | 61 | < 0.1% | |
| Other values (90376) | 97571 | 64.9% | |
| (Missing) | 27774 | 18.5% |
| Value | Count | Frequency (%) | |
| 0 | 20639 | 13.7% | |
| 1e-09 | 1041 | 0.7% | |
| 2e-09 | 538 | 0.4% | |
| 3e-09 | 377 | 0.3% | |
| 4e-09 | 285 | 0.2% | |
| 5e-09 | 230 | 0.2% | |
| 6e-09 | 192 | 0.1% | |
| 7e-09 | 176 | 0.1% | |
| 8e-09 | 150 | 0.1% | |
| 9e-09 | 135 | 0.1% |
| Value | Count | Frequency (%) | |
| 0.9999855 | 7 | < 0.1% | |
| 0.9999788 | 18 | < 0.1% | |
| 0.9999787 | 2 | < 0.1% | |
| 0.9999786 | 1 | < 0.1% | |
| 0.9999785 | 2 | < 0.1% | |
| 0.9999784 | 2 | < 0.1% | |
| 0.9999783 | 1 | < 0.1% | |
| 0.9999782 | 1 | < 0.1% | |
| 0.9999781 | 1 | < 0.1% | |
| 0.9999779 | 1 | < 0.1% |
| Distinct | 85123 |
|---|---|
| Distinct (%) | 69.5% |
| Missing | 27774 |
| Missing (%) | 18.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.01268409554 |
|---|---|
| Minimum | 0 |
| Maximum | 0.6048135 |
| Zeros | 22881 |
| Zeros (%) | 15.2% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1.07e-07 |
| median | 0.000474177 |
| Q3 | 0.0090527275 |
| 95-th percentile | 0.072486626 |
| Maximum | 0.6048135 |
| Range | 0.6048135 |
| Interquartile range (IQR) | 0.0090526205 |
Descriptive statistics
| Standard deviation | 0.03017397178 |
|---|---|
| Coefficient of variation (CV) | 2.378882411 |
| Kurtosis | 26.81607792 |
| Mean | 0.01268409554 |
| Median Absolute Deviation (MAD) | 0.000474177 |
| Skewness | 4.284667253 |
| Sum | 1554.461276 |
| Variance | 0.0009104685731 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0 | 22881 | 15.2% | |
| 1e-09 | 1229 | 0.8% | |
| 2e-09 | 637 | 0.4% | |
| 3e-09 | 447 | 0.3% | |
| 4e-09 | 333 | 0.2% | |
| 5e-09 | 284 | 0.2% | |
| 6e-09 | 236 | 0.2% | |
| 7e-09 | 207 | 0.1% | |
| 8e-09 | 192 | 0.1% | |
| 9e-09 | 161 | 0.1% | |
| 1.1e-08 | 146 | 0.1% | |
| 1e-08 | 142 | 0.1% | |
| 1.3e-08 | 115 | 0.1% | |
| 1.2e-08 | 114 | 0.1% | |
| 1.5e-08 | 103 | 0.1% | |
| 1.6e-08 | 102 | 0.1% | |
| 1.4e-08 | 99 | 0.1% | |
| 1.9e-08 | 88 | 0.1% | |
| 1.7e-08 | 87 | 0.1% | |
| 1.8e-08 | 81 | 0.1% | |
| 2e-08 | 76 | 0.1% | |
| 2.1e-08 | 74 | < 0.1% | |
| 2.3e-08 | 73 | < 0.1% | |
| 2.4e-08 | 71 | < 0.1% | |
| 2.2e-08 | 71 | < 0.1% | |
| Other values (85098) | 94503 | 62.9% | |
| (Missing) | 27774 | 18.5% |
| Value | Count | Frequency (%) | |
| 0 | 22881 | 15.2% | |
| 1e-09 | 1229 | 0.8% | |
| 2e-09 | 637 | 0.4% | |
| 3e-09 | 447 | 0.3% | |
| 4e-09 | 333 | 0.2% | |
| 5e-09 | 284 | 0.2% | |
| 6e-09 | 236 | 0.2% | |
| 7e-09 | 207 | 0.1% | |
| 8e-09 | 192 | 0.1% | |
| 9e-09 | 161 | 0.1% |
| Value | Count | Frequency (%) | |
| 0.6048135 | 1 | < 0.1% | |
| 0.4924031 | 1 | < 0.1% | |
| 0.3904803 | 1 | < 0.1% | |
| 0.3859974 | 1 | < 0.1% | |
| 0.3852026 | 1 | < 0.1% | |
| 0.3789007 | 1 | < 0.1% | |
| 0.3786497 | 1 | < 0.1% | |
| 0.3774765 | 1 | < 0.1% | |
| 0.3761325 | 1 | < 0.1% | |
| 0.3730167 | 1 | < 0.1% |
| Distinct | 91379 |
|---|---|
| Distinct (%) | 74.6% |
| Missing | 27774 |
| Missing (%) | 18.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.1137983767 |
|---|---|
| Minimum | 0 |
| Maximum | 0.9927273 |
| Zeros | 23112 |
| Zeros (%) | 15.4% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 9.775e-07 |
| median | 0.01290975 |
| Q3 | 0.157316975 |
| 95-th percentile | 0.552855205 |
| Maximum | 0.9927273 |
| Range | 0.9927273 |
| Interquartile range (IQR) | 0.1573159975 |
Descriptive statistics
| Standard deviation | 0.1818011183 |
|---|---|
| Coefficient of variation (CV) | 1.597572158 |
| Kurtosis | 2.598267545 |
| Mean | 0.1137983767 |
| Median Absolute Deviation (MAD) | 0.01290975 |
| Skewness | 1.833586731 |
| Sum | 13946.21867 |
| Variance | 0.03305164663 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0 | 23112 | 15.4% | |
| 1e-09 | 798 | 0.5% | |
| 2e-09 | 369 | 0.2% | |
| 3e-09 | 268 | 0.2% | |
| 4e-09 | 201 | 0.1% | |
| 5e-09 | 174 | 0.1% | |
| 6e-09 | 134 | 0.1% | |
| 7e-09 | 121 | 0.1% | |
| 8e-09 | 109 | 0.1% | |
| 1.1e-08 | 98 | 0.1% | |
| 9e-09 | 96 | 0.1% | |
| 1e-08 | 90 | 0.1% | |
| 1.6e-08 | 72 | < 0.1% | |
| 1.2e-08 | 70 | < 0.1% | |
| 1.4e-08 | 66 | < 0.1% | |
| 1.3e-08 | 60 | < 0.1% | |
| 1.8e-08 | 58 | < 0.1% | |
| 1.5e-08 | 56 | < 0.1% | |
| 2e-08 | 50 | < 0.1% | |
| 2.5e-08 | 47 | < 0.1% | |
| 2.1e-08 | 46 | < 0.1% | |
| 3.2e-08 | 44 | < 0.1% | |
| 2.3e-08 | 42 | < 0.1% | |
| 2.2e-08 | 42 | < 0.1% | |
| 3.6e-08 | 40 | < 0.1% | |
| Other values (91354) | 96289 | 64.1% | |
| (Missing) | 27774 | 18.5% |
| Value | Count | Frequency (%) | |
| 0 | 23112 | 15.4% | |
| 1e-09 | 798 | 0.5% | |
| 2e-09 | 369 | 0.2% | |
| 3e-09 | 268 | 0.2% | |
| 4e-09 | 201 | 0.1% | |
| 5e-09 | 174 | 0.1% | |
| 6e-09 | 134 | 0.1% | |
| 7e-09 | 121 | 0.1% | |
| 8e-09 | 109 | 0.1% | |
| 9e-09 | 96 | 0.1% |
| Value | Count | Frequency (%) | |
| 0.9927273 | 1 | < 0.1% | |
| 0.9353502 | 1 | < 0.1% | |
| 0.9348977 | 1 | < 0.1% | |
| 0.9348493 | 1 | < 0.1% | |
| 0.9348053 | 1 | < 0.1% | |
| 0.9347297 | 1 | < 0.1% | |
| 0.934194 | 1 | < 0.1% | |
| 0.9338732 | 1 | < 0.1% | |
| 0.9336993 | 1 | < 0.1% | |
| 0.9332234 | 1 | < 0.1% |
| Distinct | 82766 |
|---|---|
| Distinct (%) | 67.5% |
| Missing | 27774 |
| Missing (%) | 18.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.03590559614 |
|---|---|
| Minimum | 0 |
| Maximum | 0.7054816 |
| Zeros | 28871 |
| Zeros (%) | 19.2% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 3e-09 |
| median | 0.001368494 |
| Q3 | 0.0371501325 |
| 95-th percentile | 0.187558485 |
| Maximum | 0.7054816 |
| Range | 0.7054816 |
| Interquartile range (IQR) | 0.0371501295 |
Descriptive statistics
| Standard deviation | 0.0721742882 |
|---|---|
| Coefficient of variation (CV) | 2.010112516 |
| Kurtosis | 14.99982503 |
| Mean | 0.03590559614 |
| Median Absolute Deviation (MAD) | 0.001368494 |
| Skewness | 3.300858918 |
| Sum | 4400.302618 |
| Variance | 0.005209127877 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0 | 28871 | 19.2% | |
| 1e-09 | 1069 | 0.7% | |
| 2e-09 | 517 | 0.3% | |
| 3e-09 | 344 | 0.2% | |
| 4e-09 | 270 | 0.2% | |
| 5e-09 | 227 | 0.2% | |
| 6e-09 | 183 | 0.1% | |
| 7e-09 | 172 | 0.1% | |
| 8e-09 | 144 | 0.1% | |
| 9e-09 | 126 | 0.1% | |
| 1e-08 | 117 | 0.1% | |
| 1.1e-08 | 103 | 0.1% | |
| 1.2e-08 | 102 | 0.1% | |
| 1.3e-08 | 91 | 0.1% | |
| 1.4e-08 | 90 | 0.1% | |
| 1.5e-08 | 85 | 0.1% | |
| 1.7e-08 | 82 | 0.1% | |
| 1.9e-08 | 71 | < 0.1% | |
| 1.6e-08 | 71 | < 0.1% | |
| 2.1e-08 | 67 | < 0.1% | |
| 1.8e-08 | 64 | < 0.1% | |
| 2.2e-08 | 61 | < 0.1% | |
| 2e-08 | 60 | < 0.1% | |
| 2.5e-08 | 58 | < 0.1% | |
| 2.8e-08 | 57 | < 0.1% | |
| Other values (82741) | 89450 | 59.5% | |
| (Missing) | 27774 | 18.5% |
| Value | Count | Frequency (%) | |
| 0 | 28871 | 19.2% | |
| 1e-09 | 1069 | 0.7% | |
| 2e-09 | 517 | 0.3% | |
| 3e-09 | 344 | 0.2% | |
| 4e-09 | 270 | 0.2% | |
| 5e-09 | 227 | 0.2% | |
| 6e-09 | 183 | 0.1% | |
| 7e-09 | 172 | 0.1% | |
| 8e-09 | 144 | 0.1% | |
| 9e-09 | 126 | 0.1% |
| Value | Count | Frequency (%) | |
| 0.7054816 | 1 | < 0.1% | |
| 0.7054806 | 1 | < 0.1% | |
| 0.704659 | 1 | < 0.1% | |
| 0.7036825 | 1 | < 0.1% | |
| 0.7030472 | 1 | < 0.1% | |
| 0.7000502 | 1 | < 0.1% | |
| 0.6997408 | 1 | < 0.1% | |
| 0.6994222 | 1 | < 0.1% | |
| 0.6993374 | 1 | < 0.1% | |
| 0.6989449 | 1 | < 0.1% |
| Distinct | 79311 |
|---|---|
| Distinct (%) | 64.7% |
| Missing | 27774 |
| Missing (%) | 18.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.009855090066 |
|---|---|
| Minimum | 0 |
| Maximum | 0.4488862 |
| Zeros | 28225 |
| Zeros (%) | 18.8% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 3e-09 |
| median | 0.000242716 |
| Q3 | 0.007745907 |
| 95-th percentile | 0.05354849 |
| Maximum | 0.4488862 |
| Range | 0.4488862 |
| Interquartile range (IQR) | 0.007745904 |
Descriptive statistics
| Standard deviation | 0.02424606815 |
|---|---|
| Coefficient of variation (CV) | 2.460258403 |
| Kurtosis | 33.06774253 |
| Mean | 0.009855090066 |
| Median Absolute Deviation (MAD) | 0.000242716 |
| Skewness | 4.837116386 |
| Sum | 1207.760998 |
| Variance | 0.0005878718206 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0 | 28225 | 18.8% | |
| 1e-09 | 1378 | 0.9% | |
| 2e-09 | 693 | 0.5% | |
| 3e-09 | 463 | 0.3% | |
| 4e-09 | 370 | 0.2% | |
| 5e-09 | 299 | 0.2% | |
| 6e-09 | 240 | 0.2% | |
| 7e-09 | 228 | 0.2% | |
| 8e-09 | 194 | 0.1% | |
| 9e-09 | 169 | 0.1% | |
| 1e-08 | 157 | 0.1% | |
| 1.1e-08 | 145 | 0.1% | |
| 1.2e-08 | 135 | 0.1% | |
| 1.3e-08 | 123 | 0.1% | |
| 1.5e-08 | 119 | 0.1% | |
| 1.4e-08 | 112 | 0.1% | |
| 1.7e-08 | 108 | 0.1% | |
| 1.6e-08 | 93 | 0.1% | |
| 1.9e-08 | 91 | 0.1% | |
| 2e-08 | 88 | 0.1% | |
| 2.2e-08 | 82 | 0.1% | |
| 1.8e-08 | 78 | 0.1% | |
| 2.4e-08 | 77 | 0.1% | |
| 2.1e-08 | 74 | < 0.1% | |
| 2.7e-08 | 68 | < 0.1% | |
| Other values (79286) | 88743 | 59.0% | |
| (Missing) | 27774 | 18.5% |
| Value | Count | Frequency (%) | |
| 0 | 28225 | 18.8% | |
| 1e-09 | 1378 | 0.9% | |
| 2e-09 | 693 | 0.5% | |
| 3e-09 | 463 | 0.3% | |
| 4e-09 | 370 | 0.2% | |
| 5e-09 | 299 | 0.2% | |
| 6e-09 | 240 | 0.2% | |
| 7e-09 | 228 | 0.2% | |
| 8e-09 | 194 | 0.1% | |
| 9e-09 | 169 | 0.1% |
| Value | Count | Frequency (%) | |
| 0.4488862 | 1 | < 0.1% | |
| 0.4241931 | 1 | < 0.1% | |
| 0.3445086 | 1 | < 0.1% | |
| 0.3231493 | 1 | < 0.1% | |
| 0.3166663 | 1 | < 0.1% | |
| 0.3052982 | 1 | < 0.1% | |
| 0.3033997 | 1 | < 0.1% | |
| 0.3024383 | 1 | < 0.1% | |
| 0.2993015 | 1 | < 0.1% | |
| 0.2966177 | 1 | < 0.1% |
| Distinct | 75738 |
|---|---|
| Distinct (%) | 61.8% |
| Missing | 27774 |
| Missing (%) | 18.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.01702193229 |
|---|---|
| Minimum | 0 |
| Maximum | 0.7360929 |
| Zeros | 30555 |
| Zeros (%) | 20.3% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1e-09 |
| median | 9.49395e-05 |
| Q3 | 0.00852661975 |
| 95-th percentile | 0.102254985 |
| Maximum | 0.7360929 |
| Range | 0.7360929 |
| Interquartile range (IQR) | 0.00852661875 |
Descriptive statistics
| Standard deviation | 0.04377883934 |
|---|---|
| Coefficient of variation (CV) | 2.571907736 |
| Kurtosis | 32.98175284 |
| Mean | 0.01702193229 |
| Median Absolute Deviation (MAD) | 9.49395e-05 |
| Skewness | 4.633098937 |
| Sum | 2086.071846 |
| Variance | 0.001916586774 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0 | 30555 | 20.3% | |
| 1e-09 | 1533 | 1.0% | |
| 2e-09 | 749 | 0.5% | |
| 3e-09 | 519 | 0.3% | |
| 4e-09 | 389 | 0.3% | |
| 5e-09 | 318 | 0.2% | |
| 6e-09 | 260 | 0.2% | |
| 7e-09 | 240 | 0.2% | |
| 8e-09 | 210 | 0.1% | |
| 9e-09 | 177 | 0.1% | |
| 1e-08 | 160 | 0.1% | |
| 1.2e-08 | 155 | 0.1% | |
| 1.1e-08 | 152 | 0.1% | |
| 1.4e-08 | 126 | 0.1% | |
| 1.5e-08 | 120 | 0.1% | |
| 1.3e-08 | 117 | 0.1% | |
| 1.7e-08 | 107 | 0.1% | |
| 1.8e-08 | 99 | 0.1% | |
| 1.6e-08 | 98 | 0.1% | |
| 2e-08 | 90 | 0.1% | |
| 1.9e-08 | 88 | 0.1% | |
| 2.2e-08 | 87 | 0.1% | |
| 2.1e-08 | 80 | 0.1% | |
| 2.3e-08 | 78 | 0.1% | |
| 2.5e-08 | 76 | 0.1% | |
| Other values (75713) | 85969 | 57.2% | |
| (Missing) | 27774 | 18.5% |
| Value | Count | Frequency (%) | |
| 0 | 30555 | 20.3% | |
| 1e-09 | 1533 | 1.0% | |
| 2e-09 | 749 | 0.5% | |
| 3e-09 | 519 | 0.3% | |
| 4e-09 | 389 | 0.3% | |
| 5e-09 | 318 | 0.2% | |
| 6e-09 | 260 | 0.2% | |
| 7e-09 | 240 | 0.2% | |
| 8e-09 | 210 | 0.1% | |
| 9e-09 | 177 | 0.1% |
| Value | Count | Frequency (%) | |
| 0.7360929 | 1 | < 0.1% | |
| 0.7334418 | 1 | < 0.1% | |
| 0.7277426 | 1 | < 0.1% | |
| 0.7235098 | 1 | < 0.1% | |
| 0.7201191 | 1 | < 0.1% | |
| 0.7160151 | 1 | < 0.1% | |
| 0.7145 | 1 | < 0.1% | |
| 0.7053956 | 1 | < 0.1% | |
| 0.7007926 | 1 | < 0.1% | |
| 0.6988145 | 1 | < 0.1% |
| Distinct | 121609 |
|---|---|
| Distinct (%) | 99.2% |
| Missing | 27774 |
| Missing (%) | 18.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -0.1012832004 |
|---|---|
| Minimum | -0.9999734 |
| Maximum | 0.9826003 |
| Zeros | 278 |
| Zeros (%) | 0.2% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | -0.9999734 |
|---|---|
| 5-th percentile | -0.64372033 |
| Q1 | -0.220288725 |
| median | -0.061585745 |
| Q3 | -0.0008832305 |
| 95-th percentile | 0.427949275 |
| Maximum | 0.9826003 |
| Range | 1.9825737 |
| Interquartile range (IQR) | 0.2194054945 |
Descriptive statistics
| Standard deviation | 0.2959490345 |
|---|---|
| Coefficient of variation (CV) | -2.921995292 |
| Kurtosis | 1.990424011 |
| Mean | -0.1012832004 |
| Median Absolute Deviation (MAD) | 0.091982645 |
| Skewness | 0.05669428211 |
| Sum | -12412.45877 |
| Variance | 0.08758583105 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0 | 278 | 0.2% | |
| -0.9999734 | 66 | < 0.1% | |
| -1e-09 | 32 | < 0.1% | |
| -2e-09 | 17 | < 0.1% | |
| -3e-09 | 11 | < 0.1% | |
| 1e-09 | 9 | < 0.1% | |
| -5e-09 | 9 | < 0.1% | |
| -4e-09 | 8 | < 0.1% | |
| 2e-09 | 5 | < 0.1% | |
| -6e-09 | 5 | < 0.1% | |
| -8e-09 | 5 | < 0.1% | |
| -1.6e-08 | 4 | < 0.1% | |
| -1.5e-08 | 4 | < 0.1% | |
| -1e-08 | 4 | < 0.1% | |
| -2e-08 | 4 | < 0.1% | |
| -0.9999731 | 4 | < 0.1% | |
| -7e-09 | 4 | < 0.1% | |
| -0.9999729 | 4 | < 0.1% | |
| -0.9999728 | 3 | < 0.1% | |
| -0.1157305 | 3 | < 0.1% | |
| -6.8e-08 | 3 | < 0.1% | |
| -2.3e-08 | 3 | < 0.1% | |
| -0.9999732 | 3 | < 0.1% | |
| -0.9999716 | 3 | < 0.1% | |
| -1.4e-08 | 3 | < 0.1% | |
| Other values (121584) | 122058 | 81.2% | |
| (Missing) | 27774 | 18.5% |
| Value | Count | Frequency (%) | |
| -0.9999734 | 66 | < 0.1% | |
| -0.9999733 | 1 | < 0.1% | |
| -0.9999732 | 3 | < 0.1% | |
| -0.9999731 | 4 | < 0.1% | |
| -0.999973 | 2 | < 0.1% | |
| -0.9999729 | 4 | < 0.1% | |
| -0.9999728 | 3 | < 0.1% | |
| -0.9999726 | 2 | < 0.1% | |
| -0.9999725 | 2 | < 0.1% | |
| -0.9999724 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0.9826003 | 1 | < 0.1% | |
| 0.981972 | 1 | < 0.1% | |
| 0.9817886 | 1 | < 0.1% | |
| 0.9803576 | 1 | < 0.1% | |
| 0.9785569 | 1 | < 0.1% | |
| 0.9779928 | 1 | < 0.1% | |
| 0.9763026 | 1 | < 0.1% | |
| 0.975021 | 1 | < 0.1% | |
| 0.973827 | 1 | < 0.1% | |
| 0.9719948 | 1 | < 0.1% |
| Distinct | 115643 |
|---|---|
| Distinct (%) | 94.4% |
| Missing | 27774 |
| Missing (%) | 18.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.3568374717 |
|---|---|
| Minimum | 0 |
| Maximum | 0.99 |
| Zeros | 32 |
| Zeros (%) | < 0.1% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.030164656 |
| Q1 | 0.2244962 |
| median | 0.3677954 |
| Q3 | 0.48362425 |
| 95-th percentile | 0.670700725 |
| Maximum | 0.99 |
| Range | 0.99 |
| Interquartile range (IQR) | 0.25912805 |
Descriptive statistics
| Standard deviation | 0.1907133802 |
|---|---|
| Coefficient of variation (CV) | 0.5344544656 |
| Kurtosis | -0.5156902504 |
| Mean | 0.3568374717 |
| Median Absolute Deviation (MAD) | 0.1244427 |
| Skewness | -0.005156666891 |
| Sum | 43731.14583 |
| Variance | 0.0363715934 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0.2475 | 90 | 0.1% | |
| 0 | 32 | < 0.1% | |
| 0.2474999 | 13 | < 0.1% | |
| 0.3499243 | 10 | < 0.1% | |
| 0.2682682 | 9 | < 0.1% | |
| 0.4160468 | 8 | < 0.1% | |
| 0.6633414 | 7 | < 0.1% | |
| 0.6904675 | 7 | < 0.1% | |
| 0.1038396 | 7 | < 0.1% | |
| 0.4092008 | 6 | < 0.1% | |
| 0.3709508 | 6 | < 0.1% | |
| 0.3369608 | 6 | < 0.1% | |
| 0.1886182 | 6 | < 0.1% | |
| 0.03437681 | 5 | < 0.1% | |
| 0.352317 | 5 | < 0.1% | |
| 0.4204119 | 5 | < 0.1% | |
| 0.2474998 | 5 | < 0.1% | |
| 0.7063538 | 5 | < 0.1% | |
| 0.4648589 | 5 | < 0.1% | |
| 0.6470837 | 5 | < 0.1% | |
| 0.4047613 | 5 | < 0.1% | |
| 0.3873554 | 5 | < 0.1% | |
| 0.4183533 | 5 | < 0.1% | |
| 0.3287611 | 5 | < 0.1% | |
| 0.2474996 | 5 | < 0.1% | |
| Other values (115618) | 122285 | 81.3% | |
| (Missing) | 27774 | 18.5% |
| Value | Count | Frequency (%) | |
| 0 | 32 | < 0.1% | |
| 5.1e-08 | 1 | < 0.1% | |
| 5.2e-08 | 1 | < 0.1% | |
| 5.4e-08 | 1 | < 0.1% | |
| 5.5e-08 | 1 | < 0.1% | |
| 5.6e-08 | 1 | < 0.1% | |
| 5.7e-08 | 1 | < 0.1% | |
| 5.8e-08 | 1 | < 0.1% | |
| 5.9e-08 | 1 | < 0.1% | |
| 6.1e-08 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0.99 | 4 | < 0.1% | |
| 0.9899511 | 2 | < 0.1% | |
| 0.9898787 | 1 | < 0.1% | |
| 0.9897833 | 1 | < 0.1% | |
| 0.9897594 | 1 | < 0.1% | |
| 0.9896422 | 1 | < 0.1% | |
| 0.9895517 | 1 | < 0.1% | |
| 0.989139 | 1 | < 0.1% | |
| 0.9887384 | 1 | < 0.1% | |
| 0.9882446 | 1 | < 0.1% |
| Distinct | 64 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 51848 |
| Missing (%) | 34.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 68.26792786 |
|---|---|
| Minimum | 50 |
| Maximum | 120 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 50 |
|---|---|
| 5-th percentile | 56 |
| Q1 | 62 |
| median | 67 |
| Q3 | 73 |
| 95-th percentile | 87 |
| Maximum | 120 |
| Range | 70 |
| Interquartile range (IQR) | 11 |
Descriptive statistics
| Standard deviation | 9.178520149 |
|---|---|
| Coefficient of variation (CV) | 0.1344484949 |
| Kurtosis | 0.6596850038 |
| Mean | 68.26792786 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 0.8168750356 |
| Sum | 6722889 |
| Variance | 84.24523212 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 64 | 6681 | 4.4% | |
| 65 | 6212 | 4.1% | |
| 67 | 5346 | 3.6% | |
| 66 | 4926 | 3.3% | |
| 69 | 4749 | 3.2% | |
| 68 | 4686 | 3.1% | |
| 63 | 4492 | 3.0% | |
| 59 | 4204 | 2.8% | |
| 70 | 4130 | 2.7% | |
| 60 | 4129 | 2.7% | |
| 61 | 3779 | 2.5% | |
| 71 | 3170 | 2.1% | |
| 62 | 3166 | 2.1% | |
| 72 | 2867 | 1.9% | |
| 73 | 2787 | 1.9% | |
| 58 | 2731 | 1.8% | |
| 57 | 2018 | 1.3% | |
| 74 | 1940 | 1.3% | |
| 75 | 1858 | 1.2% | |
| 76 | 1596 | 1.1% | |
| 78 | 1474 | 1.0% | |
| 80 | 1434 | 1.0% | |
| 79 | 1378 | 0.9% | |
| 81 | 1376 | 0.9% | |
| 82 | 1371 | 0.9% | |
| Other values (39) | 15978 | 10.6% | |
| (Missing) | 51848 | 34.5% |
| Value | Count | Frequency (%) | |
| 50 | 718 | 0.5% | |
| 51 | 582 | 0.4% | |
| 52 | 367 | 0.2% | |
| 53 | 947 | 0.6% | |
| 54 | 716 | 0.5% | |
| 55 | 1166 | 0.8% | |
| 56 | 1348 | 0.9% | |
| 57 | 2018 | 1.3% | |
| 58 | 2731 | 1.8% | |
| 59 | 4204 | 2.8% |
| Value | Count | Frequency (%) | |
| 120 | 1 | < 0.1% | |
| 119 | 1 | < 0.1% | |
| 117 | 1 | < 0.1% | |
| 115 | 1 | < 0.1% | |
| 113 | 1 | < 0.1% | |
| 109 | 1 | < 0.1% | |
| 107 | 10 | < 0.1% | |
| 106 | 47 | < 0.1% | |
| 105 | 35 | < 0.1% | |
| 104 | 32 | < 0.1% |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| 2020-09-18 |
|---|
| Value | Count | Frequency (%) | |
| 2020-09-18 | 150326 | 100.0% |
Frequencies of value counts
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Histogram of lengths of the category
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Most occurring characters
| Value | Count | Frequency (%) | |
| 0 | 450978 | 30.0% | |
| 2 | 300652 | 20.0% | |
| - | 300652 | 20.0% | |
| 9 | 150326 | 10.0% | |
| 1 | 150326 | 10.0% | |
| 8 | 150326 | 10.0% |
Most occurring categories
| Value | Count | Frequency (%) | |
| Decimal Number | 1202608 | 80.0% | |
| Dash Punctuation | 300652 | 20.0% |
Most frequent Decimal Number characters
| Value | Count | Frequency (%) | |
| 0 | 450978 | 37.5% | |
| 2 | 300652 | 25.0% | |
| 9 | 150326 | 12.5% | |
| 1 | 150326 | 12.5% | |
| 8 | 150326 | 12.5% |
Most frequent Dash Punctuation characters
| Value | Count | Frequency (%) | |
| - | 300652 | 100.0% |
Most occurring scripts
| Value | Count | Frequency (%) | |
| Common | 1503260 | 100.0% |
Most frequent Common characters
| Value | Count | Frequency (%) | |
| 0 | 450978 | 30.0% | |
| 2 | 300652 | 20.0% | |
| - | 300652 | 20.0% | |
| 9 | 150326 | 10.0% | |
| 1 | 150326 | 10.0% | |
| 8 | 150326 | 10.0% |
Most occurring blocks
| Value | Count | Frequency (%) | |
| ASCII | 1503260 | 100.0% |
Most frequent ASCII characters
| Value | Count | Frequency (%) | |
| 0 | 450978 | 30.0% | |
| 2 | 300652 | 20.0% | |
| - | 300652 | 20.0% | |
| 9 | 150326 | 10.0% | |
| 1 | 150326 | 10.0% | |
| 8 | 150326 | 10.0% |
| Distinct | 59471 |
|---|---|
| Distinct (%) | 39.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| 00:15:55.440000 | 4 |
|---|---|
| 00:11:32.400000 | 4 |
| 00:15:22.680000 | 4 |
| 00:23:42 | 4 |
| 00:15:40.320000 | 4 |
| Other values (59466) |
| Value | Count | Frequency (%) | |
| 00:15:55.440000 | 4 | < 0.1% | |
| 00:11:32.400000 | 4 | < 0.1% | |
| 00:15:22.680000 | 4 | < 0.1% | |
| 00:23:42 | 4 | < 0.1% | |
| 00:15:40.320000 | 4 | < 0.1% | |
| 00:10:17.280000 | 4 | < 0.1% | |
| 00:20:52.560000 | 4 | < 0.1% | |
| 00:18:33.119000 | 4 | < 0.1% | |
| 00:02:22.320000 | 4 | < 0.1% | |
| 00:03:54.480000 | 4 | < 0.1% | |
| 00:02:27.840000 | 4 | < 0.1% | |
| 00:04:50.880000 | 4 | < 0.1% | |
| 00:02:41.760000 | 4 | < 0.1% | |
| 00:06:26.760000 | 4 | < 0.1% | |
| 00:08:44.160000 | 4 | < 0.1% | |
| 00:19:18.240000 | 4 | < 0.1% | |
| 00:04:42.839000 | 4 | < 0.1% | |
| 00:19:40.560000 | 4 | < 0.1% | |
| 00:05:05.520000 | 4 | < 0.1% | |
| 00:03:18 | 4 | < 0.1% | |
| 00:11:57.120000 | 4 | < 0.1% | |
| 00:23:41.040000 | 4 | < 0.1% | |
| 00:18:25.080000 | 4 | < 0.1% | |
| 00:20:00.600000 | 4 | < 0.1% | |
| 00:23:22.560000 | 4 | < 0.1% | |
| Other values (59446) | 150226 | 99.9% |
Frequencies of value counts
Unique
| Unique | 12279 ? |
|---|---|
| Unique (%) | 8.2% |
Histogram of lengths of the category
Length
| Max length | 15 |
|---|---|
| Median length | 15 |
| Mean length | 14.72680042 |
| Min length | 8 |
Most occurring characters
| Value | Count | Frequency (%) | |
| 0 | 1008567 | 45.6% | |
| : | 300652 | 13.6% | |
| . | 144459 | 6.5% | |
| 2 | 139584 | 6.3% | |
| 1 | 123507 | 5.6% | |
| 4 | 100648 | 4.5% | |
| 3 | 82329 | 3.7% | |
| 8 | 73111 | 3.3% | |
| 6 | 72246 | 3.3% | |
| 5 | 70896 | 3.2% | |
| 9 | 54818 | 2.5% | |
| 7 | 43004 | 1.9% |
Most occurring categories
| Value | Count | Frequency (%) | |
| Decimal Number | 1768710 | 79.9% | |
| Other Punctuation | 445111 | 20.1% |
Most frequent Decimal Number characters
| Value | Count | Frequency (%) | |
| 0 | 1008567 | 57.0% | |
| 2 | 139584 | 7.9% | |
| 1 | 123507 | 7.0% | |
| 4 | 100648 | 5.7% | |
| 3 | 82329 | 4.7% | |
| 8 | 73111 | 4.1% | |
| 6 | 72246 | 4.1% | |
| 5 | 70896 | 4.0% | |
| 9 | 54818 | 3.1% | |
| 7 | 43004 | 2.4% |
Most frequent Other Punctuation characters
| Value | Count | Frequency (%) | |
| : | 300652 | 67.5% | |
| . | 144459 | 32.5% |
Most occurring scripts
| Value | Count | Frequency (%) | |
| Common | 2213821 | 100.0% |
Most frequent Common characters
| Value | Count | Frequency (%) | |
| 0 | 1008567 | 45.6% | |
| : | 300652 | 13.6% | |
| . | 144459 | 6.5% | |
| 2 | 139584 | 6.3% | |
| 1 | 123507 | 5.6% | |
| 4 | 100648 | 4.5% | |
| 3 | 82329 | 3.7% | |
| 8 | 73111 | 3.3% | |
| 6 | 72246 | 3.3% | |
| 5 | 70896 | 3.2% | |
| 9 | 54818 | 2.5% | |
| 7 | 43004 | 1.9% |
Most occurring blocks
| Value | Count | Frequency (%) | |
| ASCII | 2213821 | 100.0% |
Most frequent ASCII characters
| Value | Count | Frequency (%) | |
| 0 | 1008567 | 45.6% | |
| : | 300652 | 13.6% | |
| . | 144459 | 6.5% | |
| 2 | 139584 | 6.3% | |
| 1 | 123507 | 5.6% | |
| 4 | 100648 | 4.5% | |
| 3 | 82329 | 3.7% | |
| 8 | 73111 | 3.3% | |
| 6 | 72246 | 3.3% | |
| 5 | 70896 | 3.2% | |
| 9 | 54818 | 2.5% | |
| 7 | 43004 | 1.9% |
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| Control2 | |
|---|---|
| Control1 | |
| Paciente1 | |
| Paciente2 |
| Value | Count | Frequency (%) | |
| Control2 | 54590 | 36.3% | |
| Control1 | 47192 | 31.4% | |
| Paciente1 | 35826 | 23.8% | |
| Paciente2 | 12718 | 8.5% |
Frequencies of value counts
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Histogram of lengths of the category
Length
| Max length | 9 |
|---|---|
| Median length | 8 |
| Mean length | 8.322924843 |
| Min length | 8 |
Most occurring characters
| Value | Count | Frequency (%) | |
| o | 203564 | 16.3% | |
| n | 150326 | 12.0% | |
| t | 150326 | 12.0% | |
| C | 101782 | 8.1% | |
| r | 101782 | 8.1% | |
| l | 101782 | 8.1% | |
| e | 97088 | 7.8% | |
| 1 | 83018 | 6.6% | |
| 2 | 67308 | 5.4% | |
| P | 48544 | 3.9% | |
| a | 48544 | 3.9% | |
| c | 48544 | 3.9% | |
| i | 48544 | 3.9% |
Most occurring categories
| Value | Count | Frequency (%) | |
| Lowercase Letter | 950500 | 76.0% | |
| Uppercase Letter | 150326 | 12.0% | |
| Decimal Number | 150326 | 12.0% |
Most frequent Uppercase Letter characters
| Value | Count | Frequency (%) | |
| C | 101782 | 67.7% | |
| P | 48544 | 32.3% |
Most frequent Lowercase Letter characters
| Value | Count | Frequency (%) | |
| o | 203564 | 21.4% | |
| n | 150326 | 15.8% | |
| t | 150326 | 15.8% | |
| r | 101782 | 10.7% | |
| l | 101782 | 10.7% | |
| e | 97088 | 10.2% | |
| a | 48544 | 5.1% | |
| c | 48544 | 5.1% | |
| i | 48544 | 5.1% |
Most frequent Decimal Number characters
| Value | Count | Frequency (%) | |
| 1 | 83018 | 55.2% | |
| 2 | 67308 | 44.8% |
Most occurring scripts
| Value | Count | Frequency (%) | |
| Latin | 1100826 | 88.0% | |
| Common | 150326 | 12.0% |
Most frequent Latin characters
| Value | Count | Frequency (%) | |
| o | 203564 | 18.5% | |
| n | 150326 | 13.7% | |
| t | 150326 | 13.7% | |
| C | 101782 | 9.2% | |
| r | 101782 | 9.2% | |
| l | 101782 | 9.2% | |
| e | 97088 | 8.8% | |
| P | 48544 | 4.4% | |
| a | 48544 | 4.4% | |
| c | 48544 | 4.4% | |
| i | 48544 | 4.4% |
Most frequent Common characters
| Value | Count | Frequency (%) | |
| 1 | 83018 | 55.2% | |
| 2 | 67308 | 44.8% |
Most occurring blocks
| Value | Count | Frequency (%) | |
| ASCII | 1251152 | 100.0% |
Most frequent ASCII characters
| Value | Count | Frequency (%) | |
| o | 203564 | 16.3% | |
| n | 150326 | 12.0% | |
| t | 150326 | 12.0% | |
| C | 101782 | 8.1% | |
| r | 101782 | 8.1% | |
| l | 101782 | 8.1% | |
| e | 97088 | 7.8% | |
| 1 | 83018 | 6.6% | |
| 2 | 67308 | 5.4% | |
| P | 48544 | 3.9% | |
| a | 48544 | 3.9% | |
| c | 48544 | 3.9% | |
| i | 48544 | 3.9% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| Controles | |
|---|---|
| Pacientes |
| Value | Count | Frequency (%) | |
| Controles | 101782 | 67.7% | |
| Pacientes | 48544 | 32.3% |
Frequencies of value counts
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Histogram of lengths of the category
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 9 |
| Min length | 9 |
Most occurring characters
| Value | Count | Frequency (%) | |
| o | 203564 | 15.0% | |
| e | 198870 | 14.7% | |
| n | 150326 | 11.1% | |
| t | 150326 | 11.1% | |
| s | 150326 | 11.1% | |
| C | 101782 | 7.5% | |
| r | 101782 | 7.5% | |
| l | 101782 | 7.5% | |
| P | 48544 | 3.6% | |
| a | 48544 | 3.6% | |
| c | 48544 | 3.6% | |
| i | 48544 | 3.6% |
Most occurring categories
| Value | Count | Frequency (%) | |
| Lowercase Letter | 1202608 | 88.9% | |
| Uppercase Letter | 150326 | 11.1% |
Most frequent Uppercase Letter characters
| Value | Count | Frequency (%) | |
| C | 101782 | 67.7% | |
| P | 48544 | 32.3% |
Most frequent Lowercase Letter characters
| Value | Count | Frequency (%) | |
| o | 203564 | 16.9% | |
| e | 198870 | 16.5% | |
| n | 150326 | 12.5% | |
| t | 150326 | 12.5% | |
| s | 150326 | 12.5% | |
| r | 101782 | 8.5% | |
| l | 101782 | 8.5% | |
| a | 48544 | 4.0% | |
| c | 48544 | 4.0% | |
| i | 48544 | 4.0% |
Most occurring scripts
| Value | Count | Frequency (%) | |
| Latin | 1352934 | 100.0% |
Most frequent Latin characters
| Value | Count | Frequency (%) | |
| o | 203564 | 15.0% | |
| e | 198870 | 14.7% | |
| n | 150326 | 11.1% | |
| t | 150326 | 11.1% | |
| s | 150326 | 11.1% | |
| C | 101782 | 7.5% | |
| r | 101782 | 7.5% | |
| l | 101782 | 7.5% | |
| P | 48544 | 3.6% | |
| a | 48544 | 3.6% | |
| c | 48544 | 3.6% | |
| i | 48544 | 3.6% |
Most occurring blocks
| Value | Count | Frequency (%) | |
| ASCII | 1352934 | 100.0% |
Most frequent ASCII characters
| Value | Count | Frequency (%) | |
| o | 203564 | 15.0% | |
| e | 198870 | 14.7% | |
| n | 150326 | 11.1% | |
| t | 150326 | 11.1% | |
| s | 150326 | 11.1% | |
| C | 101782 | 7.5% | |
| r | 101782 | 7.5% | |
| l | 101782 | 7.5% | |
| P | 48544 | 3.6% | |
| a | 48544 | 3.6% | |
| c | 48544 | 3.6% | |
| i | 48544 | 3.6% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| Video_Time | Neutral | Happy | Sad | Angry | Surprised | Scared | Disgusted | Contempt | Valence | Arousal | Heart_Rate | Fecha | Hora | ID | ID_Group | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2020-09-18 00:00:00.000 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2020-09-18 | 00:00:00 | Control1 | Controles |
| 1 | 2020-09-18 00:00:00.040 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2020-09-18 | 00:00:00.040000 | Control1 | Controles |
| 2 | 2020-09-18 00:00:00.080 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2020-09-18 | 00:00:00.080000 | Control1 | Controles |
| 3 | 2020-09-18 00:00:00.120 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2020-09-18 | 00:00:00.120000 | Control1 | Controles |
| 4 | 2020-09-18 00:00:00.160 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2020-09-18 | 00:00:00.160000 | Control1 | Controles |
| 5 | 2020-09-18 00:00:00.200 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2020-09-18 | 00:00:00.200000 | Control1 | Controles |
| 6 | 2020-09-18 00:00:00.240 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2020-09-18 | 00:00:00.240000 | Control1 | Controles |
| 7 | 2020-09-18 00:00:00.280 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2020-09-18 | 00:00:00.280000 | Control1 | Controles |
| 8 | 2020-09-18 00:00:00.320 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2020-09-18 | 00:00:00.320000 | Control1 | Controles |
| 9 | 2020-09-18 00:00:00.360 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2020-09-18 | 00:00:00.360000 | Control1 | Controles |
Last rows
| Video_Time | Neutral | Happy | Sad | Angry | Surprised | Scared | Disgusted | Contempt | Valence | Arousal | Heart_Rate | Fecha | Hora | ID | ID_Group | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 150316 | 2020-09-18 00:25:24.959 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2020-09-18 | 00:25:24.959000 | Paciente2 | Pacientes |
| 150317 | 2020-09-18 00:25:25.080 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2020-09-18 | 00:25:25.080000 | Paciente2 | Pacientes |
| 150318 | 2020-09-18 00:25:25.199 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2020-09-18 | 00:25:25.199000 | Paciente2 | Pacientes |
| 150319 | 2020-09-18 00:25:25.320 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2020-09-18 | 00:25:25.320000 | Paciente2 | Pacientes |
| 150320 | 2020-09-18 00:25:25.439 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2020-09-18 | 00:25:25.439000 | Paciente2 | Pacientes |
| 150321 | 2020-09-18 00:25:25.560 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2020-09-18 | 00:25:25.560000 | Paciente2 | Pacientes |
| 150322 | 2020-09-18 00:25:25.679 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2020-09-18 | 00:25:25.679000 | Paciente2 | Pacientes |
| 150323 | 2020-09-18 00:25:25.800 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2020-09-18 | 00:25:25.800000 | Paciente2 | Pacientes |
| 150324 | 2020-09-18 00:25:25.919 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2020-09-18 | 00:25:25.919000 | Paciente2 | Pacientes |
| 150325 | 2020-09-18 00:25:26.040 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2020-09-18 | 00:25:26.040000 | Paciente2 | Pacientes |